-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 06, 2011 at 05:55 PM
-- Server version: 5.1.40
-- PHP Version: 5.2.12

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `5`
--

-- --------------------------------------------------------

--
-- Table structure for table `tb_100x100`
--

DROP TABLE IF EXISTS `tb_100x100`;
CREATE TABLE IF NOT EXISTS `tb_100x100` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `tarif` tinyint(1) NOT NULL,
  `link` varchar(160) NOT NULL,
  `img` varchar(160) NOT NULL,
  `keyto` mediumint(8) NOT NULL,
  `cena` float(9,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_100x100`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_100x1002`
--

DROP TABLE IF EXISTS `tb_100x1002`;
CREATE TABLE IF NOT EXISTS `tb_100x1002` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `date` varchar(15) NOT NULL,
  `wmid` varchar(12) NOT NULL,
  `tarif` tinyint(1) NOT NULL,
  `link` varchar(160) NOT NULL,
  `img` varchar(160) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_100x1002`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_activeads`
--

DROP TABLE IF EXISTS `tb_activeads`;
CREATE TABLE IF NOT EXISTS `tb_activeads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `col` mediumint(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_activeads`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_addlink`
--

DROP TABLE IF EXISTS `tb_addlink`;
CREATE TABLE IF NOT EXISTS `tb_addlink` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `link` varchar(150) NOT NULL,
  `text` varchar(60) NOT NULL,
  `keyto` varchar(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_addlink`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_ads`
--

DROP TABLE IF EXISTS `tb_ads`;
CREATE TABLE IF NOT EXISTS `tb_ads` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `plan` int(11) NOT NULL,
  `color` tinyint(1) NOT NULL,
  `link` varchar(160) NOT NULL,
  `text` varchar(160) NOT NULL,
  `members1` int(11) NOT NULL,
  `members2` int(11) NOT NULL,
  `time` tinyint(3) NOT NULL,
  `vip` tinyint(1) NOT NULL DEFAULT '0',
  `pod` tinyint(1) NOT NULL DEFAULT '0',
  `ban` mediumint(8) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `vip` (`vip`),
  KEY `ban` (`ban`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_ads`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_ads2`
--

DROP TABLE IF EXISTS `tb_ads2`;
CREATE TABLE IF NOT EXISTS `tb_ads2` (
  `user` varchar(25) NOT NULL,
  `date` varchar(25) NOT NULL,
  `num` mediumint(8) NOT NULL,
  `ip` varchar(160) NOT NULL,
  KEY `num` (`num`),
  KEY `user` (`user`),
  KEY `date` (`date`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `tb_ads2`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_ads3`
--

DROP TABLE IF EXISTS `tb_ads3`;
CREATE TABLE IF NOT EXISTS `tb_ads3` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `plan` mediumint(8) NOT NULL,
  `color` tinyint(1) NOT NULL,
  `link` varchar(160) NOT NULL,
  `text` varchar(160) NOT NULL,
  `time` tinyint(3) NOT NULL,
  `summ` float(9,2) NOT NULL,
  `vip` tinyint(1) NOT NULL DEFAULT '0',
  `pod` tinyint(1) NOT NULL DEFAULT '0',
  `keyto` mediumint(8) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tb_ads3`
--

INSERT INTO `tb_ads3` (`id`, `user`, `plan`, `color`, `link`, `text`, `time`, `summ`, `vip`, `pod`, `keyto`) VALUES
(1, 'admin', 10000, 1, 'http://art.wmillione.ru/', '  jamals', 40, 285.00, 1, 0, 133848),
(2, 'admin', 30, 0, 'http://1111111111', '211111111111111111111111111111111111', 20, 1.00, 0, 0, 858300),
(3, 'admin', 30, 0, 'http://2222222222222222', '22222222222222222', 20, 1.00, 0, 0, 169654),
(4, 'admin', 500, 0, 'http://111111111111', '1111111111111111111111111111', 20, 10.00, 0, 0, 625039);

-- --------------------------------------------------------

--
-- Table structure for table `tb_adsban`
--

DROP TABLE IF EXISTS `tb_adsban`;
CREATE TABLE IF NOT EXISTS `tb_adsban` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `site` varchar(160) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_adsban`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_adschat`
--

DROP TABLE IF EXISTS `tb_adschat`;
CREATE TABLE IF NOT EXISTS `tb_adschat` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `date` varchar(15) NOT NULL,
  `text` varchar(60) NOT NULL,
  `link` varchar(160) NOT NULL,
  `views` mediumint(8) NOT NULL DEFAULT '0',
  `click` mediumint(8) NOT NULL DEFAULT '0',
  `tarif` tinyint(3) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_adschat`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_adschat2`
--

DROP TABLE IF EXISTS `tb_adschat2`;
CREATE TABLE IF NOT EXISTS `tb_adschat2` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `tarif` tinyint(3) NOT NULL,
  `text` varchar(60) NOT NULL,
  `link` varchar(160) NOT NULL,
  `keyto` mediumint(8) NOT NULL,
  `cena` float(9,2) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_adschat2`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_adsmail`
--

DROP TABLE IF EXISTS `tb_adsmail`;
CREATE TABLE IF NOT EXISTS `tb_adsmail` (
  `id` mediumint(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `plan` int(11) NOT NULL,
  `members` mediumint(8) NOT NULL,
  `link` varchar(160) NOT NULL,
  `title` varchar(60) NOT NULL,
  `text` varchar(1000) NOT NULL,
  `time` tinyint(3) NOT NULL,
  `pod` tinyint(1) NOT NULL,
  `tr_q` longtext NOT NULL,
  `tr_w` longtext NOT NULL,
  `tr_e` longtext NOT NULL,
  `tr_r` longtext NOT NULL,
  `tr_t` longtext NOT NULL,
  `tr_y` longtext NOT NULL,
  `tr_u` longtext NOT NULL,
  `tr_i` longtext NOT NULL,
  `tr_o` longtext NOT NULL,
  `tr_p` longtext NOT NULL,
  `tr_a` longtext NOT NULL,
  `tr_s` longtext NOT NULL,
  `tr_d` longtext NOT NULL,
  `tr_f` longtext NOT NULL,
  `tr_g` longtext NOT NULL,
  `tr_h` longtext NOT NULL,
  `tr_j` longtext NOT NULL,
  `tr_k` longtext NOT NULL,
  `tr_l` longtext NOT NULL,
  `tr_z` longtext NOT NULL,
  `tr_x` longtext NOT NULL,
  `tr_c` longtext NOT NULL,
  `tr_v` longtext NOT NULL,
  `tr_b` longtext NOT NULL,
  `tr_n` longtext NOT NULL,
  `tr_m` longtext NOT NULL,
  `tr_0` longtext NOT NULL,
  `tr_1` longtext NOT NULL,
  `tr_2` longtext NOT NULL,
  `tr_3` longtext NOT NULL,
  `tr_4` longtext NOT NULL,
  `tr_5` longtext NOT NULL,
  `tr_6` longtext NOT NULL,
  `tr_7` longtext NOT NULL,
  `tr_8` longtext NOT NULL,
  `tr_9` longtext NOT NULL,
  `tr__` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_adsmail`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_adsmail2`
--

DROP TABLE IF EXISTS `tb_adsmail2`;
CREATE TABLE IF NOT EXISTS `tb_adsmail2` (
  `id` mediumint(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `plan` varchar(8) NOT NULL,
  `link` varchar(160) NOT NULL,
  `title` varchar(60) NOT NULL,
  `text` varchar(1000) NOT NULL,
  `time` tinyint(3) NOT NULL,
  `pod` tinyint(1) NOT NULL,
  `summ` float(9,2) NOT NULL,
  `keyto` mediumint(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_adsmail2`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_advertises`
--

DROP TABLE IF EXISTS `tb_advertises`;
CREATE TABLE IF NOT EXISTS `tb_advertises` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `tarif` tinyint(1) NOT NULL,
  `link` varchar(160) NOT NULL,
  `text` varchar(160) NOT NULL,
  `keyto` mediumint(8) NOT NULL,
  `mesto` tinyint(1) NOT NULL,
  `cena` float(9,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tb_advertises`
--

INSERT INTO `tb_advertises` (`id`, `wmid`, `tarif`, `link`, `text`, `keyto`, `mesto`, `cena`) VALUES
(3, 'admin', 127, 'http://jms-engine.ru/', '  ', 503403, 0, 0.00);

-- --------------------------------------------------------

--
-- Table structure for table `tb_advertises2`
--

DROP TABLE IF EXISTS `tb_advertises2`;
CREATE TABLE IF NOT EXISTS `tb_advertises2` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `date` varchar(15) NOT NULL,
  `wmid` varchar(12) NOT NULL,
  `tarif` tinyint(1) NOT NULL,
  `link` varchar(160) NOT NULL,
  `text` varchar(160) NOT NULL,
  `mesto` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `tb_advertises2`
--

INSERT INTO `tb_advertises2` (`id`, `date`, `wmid`, `tarif`, `link`, `text`, `mesto`) VALUES
(7, '1315654458', 'admin', 0, 'http://jms-engine.ru/', '  ', 0),
(5, '1312135122', '111111111111', 100, 'http://art.wmillione.ru/', '  ', 0);

-- --------------------------------------------------------

--
-- Table structure for table `tb_auto`
--

DROP TABLE IF EXISTS `tb_auto`;
CREATE TABLE IF NOT EXISTS `tb_auto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_auto`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_autoads`
--

DROP TABLE IF EXISTS `tb_autoads`;
CREATE TABLE IF NOT EXISTS `tb_autoads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` varchar(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_autoads`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_auto_serf`
--

DROP TABLE IF EXISTS `tb_auto_serf`;
CREATE TABLE IF NOT EXISTS `tb_auto_serf` (
  `id` mediumint(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `plan` int(11) NOT NULL,
  `members` mediumint(8) NOT NULL,
  `link` varchar(160) NOT NULL,
  `text` varchar(60) NOT NULL,
  `tr_q` longtext NOT NULL,
  `tr_w` longtext NOT NULL,
  `tr_e` longtext NOT NULL,
  `tr_r` longtext NOT NULL,
  `tr_t` longtext NOT NULL,
  `tr_y` longtext NOT NULL,
  `tr_u` longtext NOT NULL,
  `tr_i` longtext NOT NULL,
  `tr_o` longtext NOT NULL,
  `tr_p` longtext NOT NULL,
  `tr_a` longtext NOT NULL,
  `tr_s` longtext NOT NULL,
  `tr_d` longtext NOT NULL,
  `tr_f` longtext NOT NULL,
  `tr_g` longtext NOT NULL,
  `tr_h` longtext NOT NULL,
  `tr_j` longtext NOT NULL,
  `tr_k` longtext NOT NULL,
  `tr_l` longtext NOT NULL,
  `tr_z` longtext NOT NULL,
  `tr_x` longtext NOT NULL,
  `tr_c` longtext NOT NULL,
  `tr_v` longtext NOT NULL,
  `tr_b` longtext NOT NULL,
  `tr_n` longtext NOT NULL,
  `tr_m` longtext NOT NULL,
  `tr_0` longtext NOT NULL,
  `tr_1` longtext NOT NULL,
  `tr_2` longtext NOT NULL,
  `tr_3` longtext NOT NULL,
  `tr_4` longtext NOT NULL,
  `tr_5` longtext NOT NULL,
  `tr_6` longtext NOT NULL,
  `tr_7` longtext NOT NULL,
  `tr_8` longtext NOT NULL,
  `tr_9` longtext NOT NULL,
  `tr__` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_auto_serf`
--

INSERT INTO `tb_auto_serf` (`id`, `user`, `plan`, `members`, `link`, `text`, `tr_q`, `tr_w`, `tr_e`, `tr_r`, `tr_t`, `tr_y`, `tr_u`, `tr_i`, `tr_o`, `tr_p`, `tr_a`, `tr_s`, `tr_d`, `tr_f`, `tr_g`, `tr_h`, `tr_j`, `tr_k`, `tr_l`, `tr_z`, `tr_x`, `tr_c`, `tr_v`, `tr_b`, `tr_n`, `tr_m`, `tr_0`, `tr_1`, `tr_2`, `tr_3`, `tr_4`, `tr_5`, `tr_6`, `tr_7`, `tr_8`, `tr_9`, `tr__`) VALUES
(1, 'admin', 5000, 0, 'http://jms-engine.ru/', '  ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `tb_auto_serf2`
--

DROP TABLE IF EXISTS `tb_auto_serf2`;
CREATE TABLE IF NOT EXISTS `tb_auto_serf2` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `plan` mediumint(8) NOT NULL,
  `link` varchar(160) NOT NULL,
  `text` varchar(160) NOT NULL,
  `summ` float(9,2) NOT NULL,
  `keyto` mediumint(8) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_auto_serf2`
--

INSERT INTO `tb_auto_serf2` (`id`, `user`, `plan`, `link`, `text`, `summ`, `keyto`) VALUES
(1, 'admin', 5000, 'http://jms-engine.ru/', '  ', 150.00, 791949);

-- --------------------------------------------------------

--
-- Table structure for table `tb_ban`
--

DROP TABLE IF EXISTS `tb_ban`;
CREATE TABLE IF NOT EXISTS `tb_ban` (
  `user` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `tb_ban`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_banip`
--

DROP TABLE IF EXISTS `tb_banip`;
CREATE TABLE IF NOT EXISTS `tb_banip` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `ip` varchar(15) NOT NULL,
  `flag` tinyint(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_banip`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_banner`
--

DROP TABLE IF EXISTS `tb_banner`;
CREATE TABLE IF NOT EXISTS `tb_banner` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `tarif` tinyint(1) NOT NULL,
  `link` varchar(160) NOT NULL,
  `img` varchar(160) NOT NULL,
  `tipo` tinyint(1) NOT NULL,
  `keyto` mediumint(8) NOT NULL,
  `cena` float(9,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_banner`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_banner2`
--

DROP TABLE IF EXISTS `tb_banner2`;
CREATE TABLE IF NOT EXISTS `tb_banner2` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `date` varchar(15) NOT NULL,
  `wmid` varchar(12) NOT NULL,
  `tarif` tinyint(1) NOT NULL,
  `link` varchar(160) NOT NULL,
  `img` varchar(160) NOT NULL,
  `mesto` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tb_banner2`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_bansite`
--

DROP TABLE IF EXISTS `tb_bansite`;
CREATE TABLE IF NOT EXISTS `tb_bansite` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `date` varchar(21) NOT NULL,
  `url` varchar(250) NOT NULL,
  `title` varchar(1) NOT NULL,
  `user` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_bansite`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_banwmid`
--

DROP TABLE IF EXISTS `tb_banwmid`;
CREATE TABLE IF NOT EXISTS `tb_banwmid` (
  `wmid` varchar(12) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `tb_banwmid`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_birjsystem`
--

DROP TABLE IF EXISTS `tb_birjsystem`;
CREATE TABLE IF NOT EXISTS `tb_birjsystem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `all_buy` int(11) DEFAULT '0',
  `all_buy_sum` double DEFAULT '0',
  `c_visit` double DEFAULT '0',
  `c_ref` double DEFAULT '0',
  `c_refvisit` double DEFAULT '0',
  `c_payment` double DEFAULT '0',
  `c_plus_s` double DEFAULT '0',
  `limit_echo` int(11) DEFAULT '100',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_birjsystem`
--

INSERT INTO `tb_birjsystem` (`id`, `all_buy`, `all_buy_sum`, `c_visit`, `c_ref`, `c_refvisit`, `c_payment`, `c_plus_s`, `limit_echo`) VALUES
(1, 0, 0, 0.01, 0.1, 0, 0.25, 6, 100);

-- --------------------------------------------------------

--
-- Table structure for table `tb_block`
--

DROP TABLE IF EXISTS `tb_block`;
CREATE TABLE IF NOT EXISTS `tb_block` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `date` varchar(21) NOT NULL,
  `time` int(11) NOT NULL,
  `link` varchar(160) NOT NULL,
  `text` varchar(60) NOT NULL,
  `user` varchar(25) NOT NULL,
  `click` int(11) NOT NULL,
  `wmid` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_block`
--

INSERT INTO `tb_block` (`id`, `date`, `time`, `link`, `text`, `user`, `click`, `wmid`) VALUES
(1, '06.05.2011 .  17:33', 1304981601, 'http://jms-engine.ru/', '  ', 'admin', 0, '000000000000');

-- --------------------------------------------------------

--
-- Table structure for table `tb_blockban`
--

DROP TABLE IF EXISTS `tb_blockban`;
CREATE TABLE IF NOT EXISTS `tb_blockban` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_blockban`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_blockhis`
--

DROP TABLE IF EXISTS `tb_blockhis`;
CREATE TABLE IF NOT EXISTS `tb_blockhis` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `date` varchar(21) NOT NULL,
  `link` varchar(160) NOT NULL,
  `text` varchar(60) NOT NULL,
  `user` varchar(25) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_blockhis`
--

INSERT INTO `tb_blockhis` (`id`, `date`, `link`, `text`, `user`, `time`) VALUES
(1, '06.05.2011 .  17:33', 'http://jms-engine.ru/', '  ', 'admin', 5000);

-- --------------------------------------------------------

--
-- Table structure for table `tb_catalog`
--

DROP TABLE IF EXISTS `tb_catalog`;
CREATE TABLE IF NOT EXISTS `tb_catalog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `link` varchar(160) NOT NULL,
  `text` varchar(250) NOT NULL,
  `date` varchar(10) NOT NULL,
  `color` mediumint(8) NOT NULL DEFAULT '0',
  `vip` mediumint(8) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `vip` (`vip`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_catalog`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_chat`
--

DROP TABLE IF EXISTS `tb_chat`;
CREATE TABLE IF NOT EXISTS `tb_chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `text` varchar(300) NOT NULL,
  `date` varchar(25) NOT NULL,
  `flag` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `flag` (`flag`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_chat`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_chat2`
--

DROP TABLE IF EXISTS `tb_chat2`;
CREATE TABLE IF NOT EXISTS `tb_chat2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_chat2`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_chat3`
--

DROP TABLE IF EXISTS `tb_chat3`;
CREATE TABLE IF NOT EXISTS `tb_chat3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_chat3`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_config`
--

DROP TABLE IF EXISTS `tb_config`;
CREATE TABLE IF NOT EXISTS `tb_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item` varchar(15) NOT NULL,
  `howmany` varchar(15) NOT NULL,
  `price` varchar(150) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1028 ;

--
-- Dumping data for table `tb_config`
--

INSERT INTO `tb_config` (`id`, `item`, `howmany`, `price`) VALUES
(128, 'kolvotrlot', '5', ''),
(129, 'kolvotdlot', '5', ''),
(130, 'cenabilletalot', '', '0.25'),
(1025, 'prizovemestolot', '1', '8'),
(1026, 'prizovemestolot', '2', '5'),
(1027, 'prizovemestolot', '3', '3');

-- --------------------------------------------------------

--
-- Table structure for table `tb_frame`
--

DROP TABLE IF EXISTS `tb_frame`;
CREATE TABLE IF NOT EXISTS `tb_frame` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `date` varchar(15) NOT NULL,
  `tarif` varchar(1) NOT NULL,
  `text` varchar(60) NOT NULL,
  `link` varchar(160) NOT NULL,
  `views` int(11) NOT NULL DEFAULT '0',
  `click` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tb_frame`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_frame2`
--

DROP TABLE IF EXISTS `tb_frame2`;
CREATE TABLE IF NOT EXISTS `tb_frame2` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `tarif` varchar(1) NOT NULL,
  `text` varchar(60) NOT NULL,
  `link` varchar(160) NOT NULL,
  `keyto` int(6) NOT NULL,
  `cena` float(9,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_frame2`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_hack`
--

DROP TABLE IF EXISTS `tb_hack`;
CREATE TABLE IF NOT EXISTS `tb_hack` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(150) NOT NULL,
  `key_n` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_hack`
--

INSERT INTO `tb_hack` (`id`, `date`, `key_n`) VALUES
(1, '1304681491', '87873');

-- --------------------------------------------------------

--
-- Table structure for table `tb_ip`
--

DROP TABLE IF EXISTS `tb_ip`;
CREATE TABLE IF NOT EXISTS `tb_ip` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `email` varchar(25) NOT NULL,
  `ip` varchar(25) NOT NULL,
  `keyto` varchar(32) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_ip`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_ipblock`
--

DROP TABLE IF EXISTS `tb_ipblock`;
CREATE TABLE IF NOT EXISTS `tb_ipblock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(15) NOT NULL,
  `wmid` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=134 ;

--
-- Dumping data for table `tb_ipblock`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_iperr`
--

DROP TABLE IF EXISTS `tb_iperr`;
CREATE TABLE IF NOT EXISTS `tb_iperr` (
  `num` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `tb_iperr`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_knb_end`
--

DROP TABLE IF EXISTS `tb_knb_end`;
CREATE TABLE IF NOT EXISTS `tb_knb_end` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_insert` varchar(50) NOT NULL,
  `user_select` varchar(50) NOT NULL,
  `sum` double NOT NULL,
  `date_start` int(11) NOT NULL,
  `date_end` int(11) NOT NULL,
  `user_insert_t` int(11) NOT NULL,
  `user_select_t` int(11) NOT NULL,
  `winner` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `tb_knb_end`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_knb_games`
--

DROP TABLE IF EXISTS `tb_knb_games`;
CREATE TABLE IF NOT EXISTS `tb_knb_games` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(50) NOT NULL,
  `type` int(1) NOT NULL,
  `sum` double NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_knb_games`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_knb_stats`
--

DROP TABLE IF EXISTS `tb_knb_stats`;
CREATE TABLE IF NOT EXISTS `tb_knb_stats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `all_games` int(11) NOT NULL DEFAULT '0',
  `all_sum` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_knb_stats`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_ks_cl`
--

DROP TABLE IF EXISTS `tb_ks_cl`;
CREATE TABLE IF NOT EXISTS `tb_ks_cl` (
  `user` varchar(25) NOT NULL,
  `click` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `tb_ks_cl`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_ks_cl2`
--

DROP TABLE IF EXISTS `tb_ks_cl2`;
CREATE TABLE IF NOT EXISTS `tb_ks_cl2` (
  `id` tinyint(1) NOT NULL AUTO_INCREMENT,
  `date1` varchar(10) NOT NULL,
  `date2` varchar(10) NOT NULL,
  `m1` float(9,2) NOT NULL,
  `m2` float(9,2) NOT NULL,
  `m3` float(9,2) NOT NULL,
  `flag` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_ks_cl2`
--

INSERT INTO `tb_ks_cl2` (`id`, `date1`, `date2`, `m1`, `m2`, `m3`, `flag`) VALUES
(1, '1.04.2011', '1.05.2011', 100.00, 50.00, 10.00, 1);

-- --------------------------------------------------------

--
-- Table structure for table `tb_ks_ref`
--

DROP TABLE IF EXISTS `tb_ks_ref`;
CREATE TABLE IF NOT EXISTS `tb_ks_ref` (
  `user` varchar(25) NOT NULL,
  `ref` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `tb_ks_ref`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_ks_ref2`
--

DROP TABLE IF EXISTS `tb_ks_ref2`;
CREATE TABLE IF NOT EXISTS `tb_ks_ref2` (
  `id` tinyint(1) NOT NULL AUTO_INCREMENT,
  `date1` varchar(10) NOT NULL,
  `date2` varchar(10) NOT NULL,
  `m1` float(9,2) NOT NULL,
  `m2` float(9,2) NOT NULL,
  `m3` float(9,2) NOT NULL,
  `flag` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_ks_ref2`
--

INSERT INTO `tb_ks_ref2` (`id`, `date1`, `date2`, `m1`, `m2`, `m3`, `flag`) VALUES
(1, '1.04.2011', '1.05.2011', 12.00, 32.00, 34.00, 1);

-- --------------------------------------------------------

--
-- Table structure for table `tb_ks_rek`
--

DROP TABLE IF EXISTS `tb_ks_rek`;
CREATE TABLE IF NOT EXISTS `tb_ks_rek` (
  `user` varchar(25) NOT NULL,
  `summ` float(9,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `tb_ks_rek`
--

INSERT INTO `tb_ks_rek` (`user`, `summ`) VALUES
('admin', 2565.00),
('admin', 2460.00);

-- --------------------------------------------------------

--
-- Table structure for table `tb_ks_rek2`
--

DROP TABLE IF EXISTS `tb_ks_rek2`;
CREATE TABLE IF NOT EXISTS `tb_ks_rek2` (
  `id` tinyint(1) NOT NULL AUTO_INCREMENT,
  `date1` varchar(10) NOT NULL,
  `date2` varchar(10) NOT NULL,
  `m1` float(9,2) NOT NULL,
  `m2` float(9,2) NOT NULL,
  `m3` float(9,2) NOT NULL,
  `flag` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_ks_rek2`
--

INSERT INTO `tb_ks_rek2` (`id`, `date1`, `date2`, `m1`, `m2`, `m3`, `flag`) VALUES
(1, '1.04.2011', '11.11.2011', 100.00, 50.00, 10.00, 1);

-- --------------------------------------------------------

--
-- Table structure for table `tb_mini`
--

DROP TABLE IF EXISTS `tb_mini`;
CREATE TABLE IF NOT EXISTS `tb_mini` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `plan` int(11) NOT NULL,
  `color` tinyint(1) NOT NULL,
  `link` varchar(160) NOT NULL,
  `text` varchar(160) NOT NULL,
  `members1` int(11) NOT NULL,
  `members2` int(11) NOT NULL,
  `time` tinyint(3) NOT NULL,
  `pod` tinyint(1) NOT NULL DEFAULT '0',
  `ban` mediumint(8) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ban` (`ban`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_mini`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_mini2`
--

DROP TABLE IF EXISTS `tb_mini2`;
CREATE TABLE IF NOT EXISTS `tb_mini2` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `plan` mediumint(8) NOT NULL,
  `color` tinyint(1) NOT NULL,
  `link` varchar(160) NOT NULL,
  `text` varchar(160) NOT NULL,
  `time` tinyint(3) NOT NULL,
  `summ` float(9,2) NOT NULL,
  `pod` tinyint(1) NOT NULL DEFAULT '0',
  `keyto` mediumint(8) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_mini2`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_mini3`
--

DROP TABLE IF EXISTS `tb_mini3`;
CREATE TABLE IF NOT EXISTS `tb_mini3` (
  `user` varchar(25) NOT NULL,
  `date` varchar(25) NOT NULL,
  `num` mediumint(8) NOT NULL,
  `ip` varchar(160) NOT NULL,
  KEY `num` (`num`),
  KEY `user` (`user`),
  KEY `date` (`date`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `tb_mini3`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_msg`
--

DROP TABLE IF EXISTS `tb_msg`;
CREATE TABLE IF NOT EXISTS `tb_msg` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `user2` varchar(25) NOT NULL,
  `date` varchar(21) NOT NULL,
  `title` varchar(160) NOT NULL,
  `text` varchar(2000) NOT NULL,
  `flag` int(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `user2` (`user2`),
  KEY `flag` (`flag`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_msg`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_msg2`
--

DROP TABLE IF EXISTS `tb_msg2`;
CREATE TABLE IF NOT EXISTS `tb_msg2` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `user2` varchar(25) NOT NULL,
  `date` varchar(21) NOT NULL,
  `title` varchar(160) NOT NULL,
  `text` varchar(2000) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `user2` (`user2`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_msg2`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_msg3`
--

DROP TABLE IF EXISTS `tb_msg3`;
CREATE TABLE IF NOT EXISTS `tb_msg3` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `text` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_msg3`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_newads`
--

DROP TABLE IF EXISTS `tb_newads`;
CREATE TABLE IF NOT EXISTS `tb_newads` (
  `id` tinyint(1) NOT NULL,
  `date` varchar(10) NOT NULL,
  `vchera` varchar(3) NOT NULL,
  `segodnya` varchar(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `tb_newads`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_news`
--

DROP TABLE IF EXISTS `tb_news`;
CREATE TABLE IF NOT EXISTS `tb_news` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `date` varchar(150) NOT NULL,
  `sub` varchar(150) NOT NULL,
  `text` varchar(2000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_news`
--

INSERT INTO `tb_news` (`id`, `date`, `sub`, `text`) VALUES
(1, '15.04.2011 .  16:02', '111111111', '');

-- --------------------------------------------------------

--
-- Table structure for table `tb_news_cm`
--

DROP TABLE IF EXISTS `tb_news_cm`;
CREATE TABLE IF NOT EXISTS `tb_news_cm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `text` varchar(360) NOT NULL,
  `text2` varchar(360) NOT NULL,
  `date` varchar(21) NOT NULL,
  `num` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_news_cm`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_pay`
--

DROP TABLE IF EXISTS `tb_pay`;
CREATE TABLE IF NOT EXISTS `tb_pay` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(12) NOT NULL,
  `summ` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_pay`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_payhistory`
--

DROP TABLE IF EXISTS `tb_payhistory`;
CREATE TABLE IF NOT EXISTS `tb_payhistory` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `date` varchar(21) NOT NULL,
  `user` varchar(25) NOT NULL,
  `summ` float(9,2) NOT NULL,
  `wm` varchar(13) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_payhistory`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_payment`
--

DROP TABLE IF EXISTS `tb_payment`;
CREATE TABLE IF NOT EXISTS `tb_payment` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `date` varchar(21) NOT NULL,
  `num` mediumint(8) NOT NULL,
  `summ` float(9,2) NOT NULL,
  `wmid` varchar(12) NOT NULL,
  `text` varchar(160) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tb_payment`
--

INSERT INTO `tb_payment` (`id`, `date`, `num`, `summ`, `wmid`, `text`) VALUES
(1, '06.05.2011 .  17:33', 0, 105.00, 'admin', ' 3 '),
(2, '06.05.2011 .  17:34', 0, 2100.00, 'admin', '  127 '),
(3, '06.05.2011 .  17:34', 0, 210.00, 'admin', '-  70 ');

-- --------------------------------------------------------

--
-- Table structure for table `tb_pin`
--

DROP TABLE IF EXISTS `tb_pin`;
CREATE TABLE IF NOT EXISTS `tb_pin` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `money` float(9,2) NOT NULL,
  `md` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_pin`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_psevdo`
--

DROP TABLE IF EXISTS `tb_psevdo`;
CREATE TABLE IF NOT EXISTS `tb_psevdo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(15) NOT NULL,
  `wmid` varchar(12) NOT NULL,
  `link` varchar(60) NOT NULL,
  `text` varchar(160) NOT NULL,
  `click1` int(11) NOT NULL,
  `click2` int(11) NOT NULL,
  `tarif` tinyint(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tb_psevdo`
--

INSERT INTO `tb_psevdo` (`id`, `date`, `wmid`, `link`, `text`, `click1`, `click2`, `tarif`) VALUES
(1, '1309319470', 'admin', 'http://art.wmillione.ru/', '  !!!', 53, 0, 0),
(4, '1310729672', 'admin', 'http://jms-engine.ru/', '  ', 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `tb_psevdo2`
--

DROP TABLE IF EXISTS `tb_psevdo2`;
CREATE TABLE IF NOT EXISTS `tb_psevdo2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `link` varchar(60) NOT NULL,
  `text` varchar(160) NOT NULL,
  `tarif` tinyint(1) NOT NULL,
  `keyto` varchar(6) NOT NULL,
  `cena` float(9,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tb_psevdo2`
--

INSERT INTO `tb_psevdo2` (`id`, `wmid`, `link`, `text`, `tarif`, `keyto`, `cena`) VALUES
(1, 'admin', 'http://art.wmillione.ru/', '  !!!', 127, '123318', 0.00),
(2, 'admin', 'http://jms-engine.ru/', '  ', 70, '541827', 0.00);

-- --------------------------------------------------------

--
-- Table structure for table `tb_refauto`
--

DROP TABLE IF EXISTS `tb_refauto`;
CREATE TABLE IF NOT EXISTS `tb_refauto` (
  `user` varchar(25) NOT NULL,
  `date` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `tb_refauto`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_refob`
--

DROP TABLE IF EXISTS `tb_refob`;
CREATE TABLE IF NOT EXISTS `tb_refob` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `date` varchar(50) NOT NULL,
  `text` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_refob`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_refpay`
--

DROP TABLE IF EXISTS `tb_refpay`;
CREATE TABLE IF NOT EXISTS `tb_refpay` (
  `id` tinyint(1) NOT NULL,
  `date` varchar(25) NOT NULL,
  `colref` mediumint(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `tb_refpay`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_res`
--

DROP TABLE IF EXISTS `tb_res`;
CREATE TABLE IF NOT EXISTS `tb_res` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `text` varchar(160) NOT NULL,
  `date` varchar(21) NOT NULL,
  `status` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_res`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_rost_lotareya_by_billets`
--

DROP TABLE IF EXISTS `tb_rost_lotareya_by_billets`;
CREATE TABLE IF NOT EXISTS `tb_rost_lotareya_by_billets` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `user` varchar(40) NOT NULL,
  `billet` int(4) NOT NULL,
  `time` int(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_rost_lotareya_by_billets`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_rost_lotareya_by_history`
--

DROP TABLE IF EXISTS `tb_rost_lotareya_by_history`;
CREATE TABLE IF NOT EXISTS `tb_rost_lotareya_by_history` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `user` varchar(40) NOT NULL,
  `mesto` int(2) NOT NULL,
  `summa` varchar(10) NOT NULL,
  `data` int(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_rost_lotareya_by_history`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_statistic`
--

DROP TABLE IF EXISTS `tb_statistic`;
CREATE TABLE IF NOT EXISTS `tb_statistic` (
  `id` tinyint(1) NOT NULL,
  `allusers` mediumint(8) NOT NULL,
  `activeusers` mediumint(8) NOT NULL,
  `newusers` mediumint(8) NOT NULL,
  `allview` int(11) NOT NULL,
  `pay` mediumint(8) NOT NULL,
  `paymoney` float(9,2) NOT NULL,
  `paymoney2` float(9,2) NOT NULL,
  `task1` mediumint(8) NOT NULL,
  `task2` mediumint(8) NOT NULL,
  `task3` mediumint(8) NOT NULL,
  `about` varchar(1) NOT NULL,
  `date` varchar(21) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `tb_statistic`
--

INSERT INTO `tb_statistic` (`id`, `allusers`, `activeusers`, `newusers`, `allview`, `pay`, `paymoney`, `paymoney2`, `task1`, `task2`, `task3`, `about`, `date`) VALUES
(1, 1, 0, 0, 0, 0, 0.00, 0.00, 0, 0, 0, '', '0');

-- --------------------------------------------------------

--
-- Table structure for table `tb_task`
--

DROP TABLE IF EXISTS `tb_task`;
CREATE TABLE IF NOT EXISTS `tb_task` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `date` varchar(21) NOT NULL,
  `title` varchar(60) NOT NULL,
  `text` varchar(1000) NOT NULL,
  `urll` varchar(160) NOT NULL,
  `suma` float(9,2) NOT NULL,
  `col` mediumint(8) NOT NULL,
  `color` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_task`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_task2`
--

DROP TABLE IF EXISTS `tb_task2`;
CREATE TABLE IF NOT EXISTS `tb_task2` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `user2` varchar(25) NOT NULL,
  `date` varchar(21) NOT NULL,
  `num` mediumint(8) NOT NULL,
  `suma` float(9,2) NOT NULL,
  `text` varchar(160) NOT NULL,
  `title` varchar(160) NOT NULL,
  `flag` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `user2` (`user2`),
  KEY `num` (`num`),
  KEY `flag` (`flag`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_task2`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_task3`
--

DROP TABLE IF EXISTS `tb_task3`;
CREATE TABLE IF NOT EXISTS `tb_task3` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `user2` varchar(25) NOT NULL,
  `date` varchar(21) NOT NULL,
  `text` varchar(160) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `user2` (`user2`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_task3`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_textob`
--

DROP TABLE IF EXISTS `tb_textob`;
CREATE TABLE IF NOT EXISTS `tb_textob` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `date` varchar(15) NOT NULL,
  `tarif` varchar(1) NOT NULL,
  `text` varchar(255) NOT NULL,
  `link` varchar(160) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tb_textob`
--

INSERT INTO `tb_textob` (`id`, `wmid`, `date`, `tarif`, `text`, `link`) VALUES
(4, 'admin', '1304940823', '', '  ', 'http://jms-engine.ru/');

-- --------------------------------------------------------

--
-- Table structure for table `tb_textob2`
--

DROP TABLE IF EXISTS `tb_textob2`;
CREATE TABLE IF NOT EXISTS `tb_textob2` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `wmid` varchar(12) NOT NULL,
  `tarif` varchar(1) NOT NULL,
  `text` varchar(255) NOT NULL,
  `link` varchar(160) NOT NULL,
  `keyto` int(6) NOT NULL,
  `cena` float(9,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tb_textob2`
--

INSERT INTO `tb_textob2` (`id`, `wmid`, `tarif`, `text`, `link`, `keyto`, `cena`) VALUES
(4, 'admin', '3', '  ', 'http://jms-engine.ru/', 855365, 0.00),
(3, 'admin', '7', '  ', 'http://jms-engine.ru/', 841300, 0.00);

-- --------------------------------------------------------

--
-- Table structure for table `tb_userban`
--

DROP TABLE IF EXISTS `tb_userban`;
CREATE TABLE IF NOT EXISTS `tb_userban` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `text` varchar(160) NOT NULL,
  `date` varchar(25) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tb_userban`
--


-- --------------------------------------------------------

--
-- Table structure for table `tb_users`
--

DROP TABLE IF EXISTS `tb_users`;
CREATE TABLE IF NOT EXISTS `tb_users` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) NOT NULL,
  `password` varchar(25) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `email` varchar(150) NOT NULL,
  `pemail` varchar(13) NOT NULL,
  `wmid` varchar(12) NOT NULL,
  `referer` varchar(25) NOT NULL,
  `visits` mediumint(8) NOT NULL DEFAULT '0',
  `money` float(9,3) NOT NULL DEFAULT '0.000',
  `money2` float(9,3) NOT NULL DEFAULT '0.000',
  `joindate` varchar(150) NOT NULL,
  `lastlogdate` varchar(150) NOT NULL,
  `lastiplog` varchar(150) NOT NULL,
  `agent` longtext NOT NULL,
  `wmidon` tinyint(1) NOT NULL DEFAULT '0',
  `referals` mediumint(8) NOT NULL DEFAULT '0',
  `refon` tinyint(1) NOT NULL,
  `taskon` tinyint(1) NOT NULL,
  `zamenaon` tinyint(3) NOT NULL,
  `chat1` float(9,4) NOT NULL DEFAULT '0.0000',
  `chat2` mediumint(8) NOT NULL DEFAULT '0',
  `loginon` tinyint(1) NOT NULL,
  `active` int(1) NOT NULL DEFAULT '0',
  `lastadv` varchar(150) NOT NULL DEFAULT '0',
  `bonus1` float(9,3) NOT NULL,
  `bonus2` int(11) NOT NULL,
  `bonus3` varchar(11) NOT NULL,
  `session` varchar(32) NOT NULL,
  `bj1` tinyint(1) NOT NULL,
  `bj2` tinyint(1) NOT NULL,
  `bjdate` varchar(10) NOT NULL,
  `bjsumm` float(9,2) NOT NULL,
  `bja` tinyint(1) NOT NULL,
  `refkon` int(11) NOT NULL,
  `adsdate` varchar(50) NOT NULL DEFAULT '0',
  `avatar` varchar(50) NOT NULL DEFAULT 'no.gif',
  `banned` int(15) NOT NULL DEFAULT '0',
  `blockip` varchar(15) NOT NULL DEFAULT '',
  `blockpay` varchar(50) DEFAULT '0',
  `md5` varchar(35) DEFAULT '',
  `lastuser` varchar(50) DEFAULT '',
  `user_status` varchar(5) DEFAULT 'user',
  `refbek` float(9,3) NOT NULL DEFAULT '0.000',
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `password` (`password`),
  KEY `referer` (`referer`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `tb_users`
--

INSERT INTO `tb_users` (`id`, `username`, `password`, `ip`, `email`, `pemail`, `wmid`, `referer`, `visits`, `money`, `money2`, `joindate`, `lastlogdate`, `lastiplog`, `agent`, `wmidon`, `referals`, `refon`, `taskon`, `zamenaon`, `chat1`, `chat2`, `loginon`, `active`, `lastadv`, `bonus1`, `bonus2`, `bonus3`, `session`, `bj1`, `bj2`, `bjdate`, `bjsumm`, `bja`, `refkon`, `adsdate`, `avatar`, `banned`, `blockip`, `blockpay`, `md5`, `lastuser`, `user_status`, `refbek`) VALUES
(1, 'admin', 'admin', '127.0.0.1', 'jamals@bk.ru', 'R420594403104', '278887060074', '', 0, 0.000, 0.000, '1297519683', '1304677838', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1', 0, 0, 0, 0, 0, 0.0000, 0, 0, 0, '1304676726', 0.000, 0, '', '00ff31d4bb9646a8a65a4b4659a94e8d', 0, 0, '', 0.00, 0, 0, '0', 'no.gif', 0, '', '0', 'f528764d624db129b32c21fbca0cb8d6', '', 'user', 0.000);

-- --------------------------------------------------------

--
-- Table structure for table `tb_vyvod`
--

DROP TABLE IF EXISTS `tb_vyvod`;
CREATE TABLE IF NOT EXISTS `tb_vyvod` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `date` varchar(21) NOT NULL,
  `user` varchar(25) NOT NULL,
  `summ` float(9,2) NOT NULL,
  `ip` varchar(60) NOT NULL,
  `agent` varchar(160) NOT NULL,
  `wm` varchar(13) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tb_vyvod`
--


-- --------------------------------------------------------

--
-- Table structure for table `users_online`
--

DROP TABLE IF EXISTS `users_online`;
CREATE TABLE IF NOT EXISTS `users_online` (
  `visitor` varchar(60) NOT NULL,
  `lastvisit` int(14) NOT NULL,
  `user` varchar(150) NOT NULL,
  `page` varchar(160) NOT NULL,
  `padmin` varchar(500) NOT NULL,
  KEY `lastvisit` (`lastvisit`),
  KEY `visitor` (`visitor`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `users_online`
--


